#!/usr/bin/env bash

sql_cmd="INSERT OVERWRITE TABLE acrm_transaction select customer_id ,tran_date ,tran_type , channel , amount  from  i_acrm_transaction;"

$HIVE_HOME/bin/hive -e "$sql_cmd"